Problem Note 46520: Invalid format of DATE13. generated by EFI, PROC IMPORT, and IMPORT WIZARD
 |  |  |  |
When EFI, PROC IMPORT, or the IMPORT WIZARD encounter a date value in quotation marks like "08-May-2012", a format of DATE13. is assigned. DATE13. is invalid due to the width portion, and the following ERROR is returned for the FORMAT statement in the generated DATA step code in the SAS log:
ERROR 29-185: Width specified for format DATE is invalid.
The problem has been fixed in SAS 9.3 TS1M1.
If you are using SAS 9.3 and PROC IMPORT to read the external file, you can do one of the following workarounds:
1) Recall the generated DATA step code from the SAS log assuming you are running SAS interactively. Then modify the FORMAT statement for the variable with the invalid width by changing the width to 11. in place of 13. You can recall the generated DATA step code by doing a RUN-RECALL LAST SUBMIT after the PROC IMPORT.
2) Use a DATA step with INFILE and INPUT statements instead of PROC IMPORT to read the external file.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for x64 | 9.3 TS1M0 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Microsoft Windows XP Professional | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Enterprise 32 bit | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Enterprise x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Home Premium 32 bit | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Home Premium x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Professional 32 bit | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Professional x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Ultimate 32 bit | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows 7 Ultimate x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows Vista | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Windows Vista for x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled AIX | 9.3 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled HP-UX | 9.3 TS1M0 | 9.3 TS1M1 | ||
| 64-bit Enabled Solaris | 9.3 TS1M0 | 9.3 TS1M1 | ||
| HP-UX IPF | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Linux | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Linux for x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Solaris for x64 | 9.3 TS1M0 | 9.3 TS1M1 | ||
| Type: | Problem Note |
| Priority: | high |
| Topic: | Common Programming Tasks ==> Reading and Writing External Data ==> EFI Common Programming Tasks ==> Reading and Writing External Data ==> Import Wizard Common Programming Tasks ==> Reading and Writing External Data ==> with PROC IMPORT |
| Date Modified: | 2012-05-09 10:14:02 |
| Date Created: | 2012-05-08 15:11:07 |